Materialized Views in Oracle
نویسندگان
چکیده
Oracle Materialized Views (MVs) are designed for data warehousing and replication. For data warehousing, MVs based on inner/outer equijoins with optional aggregation, can be refreshed on transaction boundaries, on demand, or periodically. Refreshes are optimized for bulk loads and can use a multi-MV scheduler. MVs based on subqueries on remote tables support bidirectional replication. Optimization with MVs includes transparent query rewrite based on costbased selection method. The ability to rewrite a large class of queries based on a small set of MVs is supported by using Dimensions (new Oracle object), losslessness of joins, functional dependency, column equivalence, join derivability, joinback and aggregate rollup.
منابع مشابه
Materialized Views in Action
Materialized views are a powerful feature that has been part of the Oracle RDBMS since version 8.1. Based upon the snapshot replication feature, they have evolved considerably into a capable tool for significantly improving performance on queries at higher levels of hierarchical organization structures. When they are effectively implemented across an entire data warehouse, the total number of l...
متن کاملPartially Materialized Views
We propose a new type of materialized view called a partially materialized view. A partially materialized view only materializes some of the rows, for example, the most frequently accessed rows, which reduces storage space and view maintenance effort. One or more control tables are associated with the view and define which rows are currently materialized. As a result, one can easily change whic...
متن کاملComparing Materialized Views and Analytic Workspaces in Oracle Database 11g
INTRODUCTION Businesses today require information in a timely fashion. It is no longer acceptable to produce a report once a day, now some people need it hourly or even every few minutes. To be responsive to the business need for analysing an ever growing set of business data, requires performing any analysis in a timely manner. This is an increasing challenge when the analysis is over vast qua...
متن کاملSBQL Views - Prototype of Updateable Views
In this paper we describe a prototype implementation of updateable views called “SBQL Views”. The prototype follows a novel approach to view updates based on the Stack-Based Approach to object-oriented and XMLoriented query languages. The SBQL Views prototype is implemented on top of the SBQL query language for the XML DOM model. The novelty of the approach consists in augmenting a view definit...
متن کاملSpeeding Up Materialized-View Maintenance Using Cheap Filters at the Warehouse
We consider the problem of speeding up the incremental maintenance of materialized views defined by conjunctive queries (CQ) over external base relations, when querying these base relations is expensive. Our approach consists of detecting, without using the base relations, situations where a view either is not affected by a base update (VDU) or can be maintained using only the views in the ware...
متن کامل